Avg Units Available, Avg Applicants vs Avg Mths Waiting
1. Create New Sheet, 2. Rename, 3. Double click on the Title, Dialog box opens - 4. Highlight <Sheet Name> 5. Edit/Format title Size 11, Bold
Create the Stacked Bar chart
Drag and drop Program in column shelf, Units available in Row shelf, Click the Descending order icon, Drag and drop Applicants on the y-axis( when the green dual ruler icon is visible, drop applicants on the axis), Bring the Measure names pill to color, Change the measures aggregate to Average.
See gif
Dual Axis
Drag and drop Months Waiting to right axis, Change aggregate to Average, Change the Marks (Measures Values to Bar and Avg(Months Waiting) to line ), Bring Months Waiting to label, Change aggregate to Average, Edit both axis to remove title.
See gif
Color and formatting
Edit colors, double click on each field, add the color code (Avg. Applicants - #5c6068 , Avg Units Available - #006c84, Avg Months Waiting - #8493a7) , Hide Program header, Right click sheet space to edit, Right click on axis to select Format to Edit in the options on the left pane.
See gif
Tooltip
Select ALL on the Marks shelf, Drag and Drop the Avg Months Waiting indicators to Detail, Click Tooltip, Copy and paste (fields below), Preview and Click OK
<Program>
<Measure Names>: <Measure Values>
Avg. Months Waiting: <AVG(Months Waiting)><AGG(cc.YoY Mths Waiting UP)><AGG(cc.YoY Mths Waiting DOWN)>
see gif
